By default the ArchiverFS setup will look for a local SQL Express instance when installing the software. It is hard wired to look for an instance called 'SQLEXPRESS' on the local machine, unless something else has already been configured in the registry.

The steps below assume a certain degree of familiarity with SQL server. If you would like help to set this up then please don't hesitate to contact us via Support@MLtekSoftware.com. 

You can install the ArchiverFS databases to a custom SQL server by doing the following:

1) Attach the two databases enclosed in this folder manually to your custom SQL instance.

2) Grant the Windows\AD account that the software is going to use 'dbowner' rights to both of the databases. See the 'Service Account' section in the user guide for more info on setting up this user account.

3) On the machine you will be installing ArchiverFS on, create the'HKEY_LOCAL_MACHINE\SOFTWARE\MLtek\AMV3' registry key if it doesn't already exist.

4) On the machine you will be installing ArchiverFS on, add a registry string value called 'DBCONSTRING' to the 'HKEY_LOCAL_MACHINE\SOFTWARE\MLtek\AMV3' registry key and set it's value to the SQL connection string the software should use to connect to the AMDBv3 Database on your custom server. e.g. "Data Source=DBSERVER1\INSTANCE1;Database=AMDBv3;Integrated Security=True"

5) On the machine you will be installing ArchiverFS on, add a registry string value called 'REPORTDBCONSTRING' to the 'HKEY_LOCAL_MACHINE\SOFTWARE\MLtek\AMV3' registry key and set its value to the SQL connection string the software should use to connect to the AMDBv3REPORTING Database on your custom server. e.g. "Data Source=DBSERVER1\INSTANCE1;Database=AMDBv3REPORTING;Integrated Security=True"

6) Now run the ArchiverFS setup, it should detect the existing registry entries and automatically use your custom SQL instance instead of looking for a local SQL Express instance.
